Ask Your Question

conditional formatting

asked 2020-08-21 12:14:18 +0200

conrail gravatar image

updated 2020-09-21 23:08:45 +0200

Alex Kemp gravatar image

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

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2020-08-21 15:20:40 +0200

Opaque gravatar image

updated 2020-08-21 15:22:51 +0200


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

image description

Hope that helps

edit flag offensive delete link more

answered 2020-08-21 18:26:03 +0200

conrail gravatar image

updated 2020-08-22 11:40:43 +0200

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

edit flag offensive delete link more


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 …

Opaque gravatar imageOpaque ( 2020-08-21 18:30:25 +0200 )edit

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

Opaque gravatar imageOpaque ( 2020-08-21 18:38:47 +0200 )edit

thank you, will try to remember this

conrail gravatar imageconrail ( 2020-08-22 11:41:29 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-08-21 12:14:18 +0200

Seen: 75 times

Last updated: Aug 22 '20