• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

conditionally format a cell based on the adjacent cell's formula results

deekarvois

New Member
This is really frustrating me.


I thought this formula would be easy but for some reason, the conditional format is not working.


I have a range of cells (A1, B3)


The formula in B1 is a simple "if-then" such that if there is no text found, the result is ""

ACTUAL FORMULA IS:

=IF(ISTEXT('G:Employee FoldersDeeScorecardsFY 2011[State Owned Density Pivot.xlsm]Original Data (2)'!R271),'G:Employee FoldersDeeScorecardsFY 2011[State Owned Density Pivot.xlsm]Original Data (2)'!R271,"")


I now want to conditionally format A:A using contents in B:B; specifically, "".


if the result in B cell is "" then highlight A cell.


It isn't working. Can anyone help with this? TIA
 
Hi deekarvois,


Select your range in column A and in CF use formula and enter


=B1=""


Then select the format you require
 
Back
Top