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
Hello,
Step 1 - Create your desired Cell Styles
- Open your document
-
Styles -> Manage Styles(orF11 - 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 EffectsandBackground - 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:1i.e. row1) 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