| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Color a row once a "x" is entered
I need a formula that will color a row A5:O5 once "X" is entered in N5.
Thank you in advance for your help!!! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Color a row once a "x" is entered
Use conditional formatting.
Highlight A5:O5, go to formatting/conditional formatting. Choose Formula is and type =$N5="X" then pick the colour you want. "Nielly" wrote: I need a formula that will color a row A5:O5 once "X" is entered in N5. Thank you in advance for your help!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| bunch of "yes" or "no" entered in row, output 1 if a single yes | Excel Worksheet Functions | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| Any IF(A2=font color=red", "1", "0") in excel? Or a way to do it? | Excel Discussion (Misc queries) | |||
Linear Mode
