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
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
Hello,
Step 1 - Create your desired Cell Styles
Styles -> Manage Styles (or F11New...FTwhiteBGred)Font Effects and BackgroundOKRepeat the last four steps for all required formatting (i.e. all conditions you will define)
Step 2 - Define the Condtional Formatting
1:1 i.e. row 1)Format -> Conditional -> Condtion...Cell value is - equal to - "A" - Apply Style: FTwhiteBGred (don't forget the quotes)AddCell value is - equal to - 4 - Apply Style: FTblackBGyellowAdd ....OK
Hope that helps
Asked: 2020-08-21 12:14:18 +0200
Seen: 75 times
Last updated: Aug 22 '20
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.