| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting Separate Rows
I need to set-up three formali in each row of a 1000 row spreadsheet. The
three forumli a =A4="x" then B4 : P4 strickthrough, green font =B4<Today() B4:P4 Font Red =R4=True B4:P4 Font Purple Italic. I enter that in Row 4 , now I need to repeat this for every row, but every attempt fails to change the row identifier- thus every row ends up refering to row 4 only. Hope do I copy this instead hand writing each row- 1000 rows? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting 2 rows only | Excel Discussion (Misc queries) | |||
| Conditional formatting from list on separate sheet | Excel Discussion (Misc queries) | |||
| Conditional formatting for rows? | New Users to Excel | |||
| Conditional Formatting of rows | Excel Discussion (Misc queries) | |||
| How to get more than 3 rows in Conditional Formatting | Excel Discussion (Misc queries) | |||
Threaded Mode
