Conditional formatting Query

BarrattsMini

New Member
Joined
Mar 23, 2021
Messages
3
Office Version
  1. 2010
Platform
  1. Windows
Hi all,

First post and I did try searching but couldn't seem to find what I was looking for.

I would like to have a row highlighted in red if blank which is easy enough. But, should any cell within that row have an entry I would like the row to no longer be highlighted.

The purpose here sits around when a particular case will be put forward for a meeting. Ideally every case in the spreadsheet would be aligned to a particular meeting, once a month, for review. Sometimes however we receive a case and the owner still has to flesh out the detail and isn't willing to commit to a particular month at that moment in time. I would like the row to be a certain color, say red, so I know to chase them for a date but once they do commit I'd like the row to no longer be formatted in red.

I hope this makes sense and thank you.
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

Toadstool

Well-known Member
Joined
Mar 5, 2018
Messages
1,449
Office Version
  1. 2016
Platform
  1. Windows
Hi BarrattsMini,

You should probably restrict which rows and columns but if it's the entire sheet then this will do it:

Book1
AB
1
2
33
4
5
Sheet1
Cells with Conditional Formatting
CellConditionCell FormatStop If True
1:1048576Expression=COUNTIF(1:1,"<>")=0textNO
 

BarrattsMini

New Member
Joined
Mar 23, 2021
Messages
3
Office Version
  1. 2010
Platform
  1. Windows
Hi Toadstool,

Thanks for coming back.

I realize my query wasn't specific enough as I said "row" as though it was an entire row that needed the formatting where as it's only part of a row. So the full range would actually be R2:AC281. Sorry about this.

So Columns A through to Q have data in there and then columns R through to AC are the potential meetings they could be aligned to so far. As you can probably workout it's a meeting a month and it is currently looking at Jan of this year through to December of this year. I would like for those 12 cells in a row to be red but if I add a 'X' to any month once they commit to presenting at that meeting then none of the 12 cells in that row appear red any more ...

I'm hoping this is clearer and I apologize for my first post ...
 

Toadstool

Well-known Member
Joined
Mar 5, 2018
Messages
1,449
Office Version
  1. 2016
Platform
  1. Windows
Try this. Note the formula and range have changed

BarrattsMini.xlsx
RSTUVWXYZAAABAC
1
22/2/2021
3
41/1/2021
5TBD
6
7
83
Sheet1 (2)
Cells with Conditional Formatting
CellConditionCell FormatStop If True
R2:AC281Expression=COUNTIF($R2:$AC2,"<>")=0textNO
 

BarrattsMini

New Member
Joined
Mar 23, 2021
Messages
3
Office Version
  1. 2010
Platform
  1. Windows
Try this. Note the formula and range have changed

BarrattsMini.xlsx
RSTUVWXYZAAABAC
1
22/2/2021
3
41/1/2021
5TBD
6
7
83
Sheet1 (2)
Cells with Conditional Formatting
CellConditionCell FormatStop If True
R2:AC281Expression=COUNTIF($R2:$AC2,"<>")=0textNO
PERFECT

Thank you very much.
 

Watch MrExcel Video

Forum statistics

Threads
1,129,685
Messages
5,637,809
Members
416,983
Latest member
LessThanAverageUser

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top