Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hello.
I have a sheet where the top row, A1:E1, is a title row, and everything below that is data that'll be entered. I have set up a conditional formatting item that essentially puts a border around a row when I type something in A1... I highlighted columns A through E and then added the condition: =NOT(ISBLANK($A1)) [format so that each cell is outlined] However, and this is just one example that will help me solve a number of other issues, I want to be able to not have this condition on the first row... the title row... as I want to be able to do something else in this row. [ideally, it would be good to know if I could do separate things for a couple of rows, but the title row is the main thing for now]. For example, in the title row, I want a different style border than I did in the formatting for the rest of the rows. I hope that's enough to give a picture of what I have going on. Anyone have any thoughts on what I need to do... or is there anything I can do? As always, any help is very much appreciated. Thanks for your time. Matt |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
Copying cells with conditional formatting | Excel Discussion (Misc queries) | |||
Effect of Conditional Formatting, Data Validation | Excel Discussion (Misc queries) | |||
conditional formatting adjacent cells | Excel Worksheet Functions |