Conditional formatting greyed out in Excel is typically as a result ofthe workbook being a shared workbook. To check whether you have the shared workbook feature switched on, go to the REVIEW tab and click the SHARE WORKBOOK button. ... Note however that this does not mean you can't have...
Hi all I'm a novice when it comes to excel and was hoping for some help with conditional formatting and creating a formula. I have 3 sheets with similar layouts but different rows need to 'greyed out' depending on the number inserted at the beginning of the row. All numbers are 6 digi...
I now tried to create a gantt chart which i wanted to conditional format to At Risk, On Target, Overdue etc. However, all the options for formatting including conditional formatting are greyed out. I have tried creating a new chart, exporting the spreadsheet to another workbook but no luck ...
I'm struggling to create the conditional formatting on an excel sheet for a training record I've created. Any help would be greatly appreciated! I'm creating a training matrix where the cells in column G will initially be either red or greyed out based on whether the training module is ma...
I see a drop down that says Number but its greyed out, I have seen in other examples (maybe not conditional formatting for a card) that those drop downs are not grey and you can choose percentage. But thats not available to me. Message 8 of 8 557 Views 0 Reply SanKing Hel...
I am trying to figure out if there is a way to apply the conditional formatting rule so it won't change when I sort the rows... I am really trying to use the icon sets for presentation value. Can that be accomplished by formatting from the home tab? Monday...
So, the same name appears more than once but I only want to mark a name once, and then have the corresponding values for that name in column B greyed out every time I enter that name again – without having to mark it with an X every time. I’ve googled this in many, man...
Windows Hello greyed out facial recognition on a domain computer Windows Installer - Can not install any .MSI File Windows Installer has stopped working on Server 2012R2 Windows Internal Certificate Authority and the CRL? Windows modules installer must be updated before you can install this package ...
I fixed this small error, and this measure is still greyed out when I try to select it as the 'Based on value' in conditional formatting. Any ideas on what to do now? Message 5 of 11 2,616 Views 0 Reply MFelix Super User In response to Anonymous 03-16-2021 ...
As you can see in the image I had it so that the names are greyed out in the master column (column F) when selected in the big range you have on the left. This can be altered if you want the master column on the left and definitely altered because your range of names is bigger....