Tag Info

New answers tagged


A conditional format will contain both fill and font color. You can't set the fill with one rule and a font color with another. The latter will set the fill color, too. You will need to create a new rule that has the logic you require to identify unique and duplicate (although it's not quite clear how a unique value can be a duplicate at the same time).


This solution doesn’t require you to take special action before and after each time you need to print the file.  It builds on the idea of using a “Print Area”, as suggested by Terence and Don Livezey.  Put the cell(s) that you don’t want to print outside the print area.  If that’s good enough for you, you’re done. But you might want the excluded cell(s) to ...


Use relative references (no dollar sign), by writing down a rule for the first cell of range (ex. B2>A2)


You missed the " i tried it with =INDIRECT("sheet2!$B$2")=3 and it worked perfectly... however... the formula in your cell won't act dynamically. Having A1 refering to A2 and B1 to B2 won't work... you only can check the outcome of your formula... while just copy/pasting the formula souldn't be any problem


From a blank sheet: In A1 enter =c1 In b1 enter 5 In c1 enter 5 Select b1, click conditional formatting in the ribbon, and New Rule Click "use a formula to determine cells to format". In the formula box type =$b$1=$a$1 Click the format button and change the color to red, Click ok Click ok Click ok B1 should now have red text. Change the value in c1 ...


Create a new Conditional Formatting rule that applies to =$A:$G and use the following formula. Both Gs can be replaced with which ever end column you need. =AND(COUNTA($A1:$G1)>0, ISBLANK(A1))

Top 50 recent answers are included