Conditional Formatting

[Darren Smith]

Morning All

Could i use conditional formatting to highlight a row above filled in rows in a range?

 

[EFANYoutube]

Hi Darren
Can you please explain a bit more what you are trying to do

Thanks
ExcelFan

 

[Darren Smith]

There is a Excel Sheet which has filled in rows i need i colored line above each filled in row.
Just color in a row rather than a row added

 

[maabadi]

Select above row of filled Row ( I Suppose your filled row is 10, then Select row 9) Then Conditional formatting, Manage Rule, New rule,
Use formula to Determine ..... and type

=A10<>""

Then select format that you want and apply.

 

[Darren Smith]

Problem is I have various ranges and I am trying to fill in color rows with a click of a button rather than manually.
Using VBA Coding.

 

[Fluff]

Duplicate to: insert coloured row above filled in cells

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.