Hello

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello All,

I am using Conditional Formatting on one Cell. what I am looking for is;
when any particular value evaluates to True let's say Cell D5 = "Done" then
that complete record / row should be filled with any color. I have the idea
but want to learn more clearly.

Thanks In Advance

Mumshad
 
Use "Formula is", rather than "Cell value is", and use absolute addressing
for the column and relative addressing for the row.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Macro to automatically go to the right of the last colored cell 0
Excel VBA 1
Excel 2003 Conditional Formatting w/ 3 Conditions and a value = to 2
IF OR AND in same conditional formula 2
copying a cell that has been formatted to cell with conditionals 1
Highlighting the entire row with conditional formatting 10
conditionally formatting 3
Checking a cell's format in a function 1

Back
Top