Home |
Search |
Today's Posts |
#1
|
|||
|
|||
format based on data from another cell
I want the names in column B of my spread sheet to highlight either red or
yellow based on the value of the cell in column L, but with conditional formatting you can only format based on the value of the cell you are formatting, as far as i can tell. |
#2
|
|||
|
|||
Hi Sanna
conditional formatting can be used to do this, select the column B cells that you want the formatting to be applied to, ensure that the first selected cell is the first line visible at the top of the worksheet choose format / conditional formatting choose formula is type =$L2=x where row 2 is the first row in the selected column and x is the criteria that you want to check for click format - set your formatting click ADD repeat for the 2nd condition -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Sanna R." <Sanna wrote in message ... I want the names in column B of my spread sheet to highlight either red or yellow based on the value of the cell in column L, but with conditional formatting you can only format based on the value of the cell you are formatting, as far as i can tell. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can't format cell - have tried unlocking and unprotecting | Excel Discussion (Misc queries) | |||
Is there a way to lock out the format for the cell and still allow data entry and C&P? | New Users to Excel | |||
populating sheets based on data from parent sheets | Excel Discussion (Misc queries) | |||
Can you conditional format based on information in cell comments? | Excel Worksheet Functions | |||
Format Cell Colour | Excel Worksheet Functions |