| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell shading with conditional formatting
I use the following conditional formatting formula =MOD(ROW(),2)+1<=1 to
alternate colors for my spreadsheet. Whenever I insert a row it will automatically adjust the rows to be alternating colors. But, I cell shade (using light grey) some of the cells in this spreadsheet. Some of these greyed cells are on the WHITE rows and some are on the LIGHT BLUE rows (relating to the conditional formatting formula). I cannot see the greyed out cells when they're on the light blue rows (it doesn't show up). How can I fix this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting similar to shading alternating rows | Excel Worksheet Functions | |||
| Conditional formatting formula that uses VLookup, based on content of another cell | Excel Discussion (Misc queries) | |||
| Applying conditional formatting to cell based on another cell's in | Excel Discussion (Misc queries) | |||
| Conditional Formatting to Test Value in Cell | Excel Worksheet Functions | |||
| Why won't my conditional formatting display in the cell | Excel Discussion (Misc queries) | |||
Threaded Mode
