conditional formatting

Hi All, can somebody advise me on conditional formatting please, ie if cell 1a = A then font white, background red, if cell 1b = 4 then font black, background yellow, etc., all help and advice appreciated


Step 1 - Create your desired Cell Styles

  • Open your document
  • Styles -> Manage Styles (or F11
  • Click icon leftmost (beneath Styles), which is Cell Styles
  • Right click on Default and New...
  • Provide a name (e.g. FTwhiteBGred)
  • Make your setting in tabs Font Effects and Background
  • Click OK

Repeat the last four steps for all required formatting (i.e. all conditions you will define)

Step 2 - Define the Condtional Formatting

  • Select the cells which should contain the Condtional Formatting (e.g. 1:1 i.e. row 1)
  • Format -> Conditional -> Condtion...
  • Condtion 1 - Cell value is - equal to - "A" - Apply Style: FTwhiteBGred (don’t forget the quotes)
  • Click button Add
  • Condtion 2 - Cell value is - equal to - 4 - Apply Style: FTblackBGyellow
  • Click button Add
  • Finally click button OK

Hope that helps

thank you Opaque, that is brilliant, just what I was after, can I ask a further question please? in column A I have either “A” or “H” in which I have applied your suggestions, “A” is blue and “H” is red font, I wish to apply further conditional formatting to column F in which if A1 is red then F1is also red, and if A1 is blue then F1 is also blue, down the column for 46 entries, hope that makes sence, again your help and advice is appreciated

ot’s ok I have managed to sort the answer out, took a bit of thought but got there in the end
again thank you Opaque for starting me off, I appreciate it

Please do not use Add Answer if you actually don’t answer a question but commenting an answer or responding to another user’s comment. Please use add a comment for that purpose. Thanks in advance …

Since this is a Q&A site - ask a new question, but the idea is wrong to conditional format cells based on attributes of other cells (There is no function to get the attribute “background color” or *text color" of a cell). Instead use the same Conditional Formatting rule but use Formula is instead of Cell value is and refer to the cell (i.e use $A1="A" as a formula`) and apply the same Cell Style

thank you, will try to remember this